MTS Support

The Sybase Wire Protocol driver can take advantage of Microsoft Transaction Server (MTS) capabilities, specifically, the Distributed Transaction Coordinator (DTC). Refer to the help file of the "MicroSoft Transaction Server SDK" for details.

You can choose between Native OLE and XA protocol distributed transactions by using the DistributedTransactionModel connection string attribute documented in Table 2-1.

To enable distributed transaction in the Sybase server:

  1. Assign the dtm_tm_role to each user who will participate in distributed transactions (who will log in to Adaptive Server). You can do this using the sp_role command. For example:

    2. sp_role "grant", dtm_tm_role, user_name

    In the open string for resource managers, the specified username must have the dtm_tm_role.

  2. Specify a default database other than the master for each user. Sybase cannot start distributed transactions in a master database.